USE [master]
GO

/****** Object:  Table [dbo].[T_USER_INFO]    Script Date: 2016/9/21 10:56:53 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[T_USER_INFO](
	[F_SEQ] [varchar](20) NULL,
	[F_COMMUNITY] [varchar](100) NULL,
	[F_BUID] [varchar](50) NULL,
	[F_UNIT] [varchar](10) NULL,
	[F_ROOM] [varchar](50) NULL,
	[F_CTLID] [varchar](10) NULL,
	[F_METERID] [varchar](20) NULL,
	[F_USERID] [varchar](20) NULL,
	[F_USERNAME] [varchar](50) NULL,
	[F_MOBILENO] [varchar](20) NULL,
	[F_PHONENO] [varchar](20) NULL,
	[F_COMMENT] [varchar](500) NULL,
 CONSTRAINT [IX_T_USER_INFO] UNIQUE NONCLUSTERED 
(
	[F_USERNAME] ASC,
	[F_BUID] ASC,
	[F_UNIT] ASC,
	[F_ROOM] ASC,
	[F_MOBILENO] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

